🕷️️ Job Radar • SCRAPING

freelancer.com 2026-04-24 🟢

🔹 Refactor Python Scraper for Google Shopping Data
👤 Client: 🇦🇺 Ellenbrook, Australia Member since 2020-02-23
💰 Price: $20 Average bid
🚩 Problem: Need to update a Python scraper to capture product names, prices, and seller details from Google Shopping based on specific keywords, then push the data into an existing Google Sheet.
📦 Existing: [Not specified]

Specifications:

[Target] Capture product names, prices, and seller details from Google Shopping for given keywords
[Method] Use Python with BeautifulSoup or similar library to scrape data; use gspread to write to Google Sheets
[UI/UX] Not applicable (backend task)
[Stack] Python 3.x, BeautifulSoup, requests, gspread
[Security] Ensure secure authentication using OAuth2 for Google Sheets API
[Format] JSON for structured data handling

Workflow:

1. Install necessary dependencies: beautifulsoup4, requests, and gspread.
2. Authenticate with Google Shopping and Google Sheets via OAuth2 credentials.
3. Define a function to scrape product details from Google Shopping using provided keywords.
4. Write scraped data into the specified columns in the existing Google Sheet.
5. Test the script manually by running it and verifying the data appears correctly.